Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
SizeCode (FK)(PK) | A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRF to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. | CD_SZ | Code6 | char(6) | Size(CO_SZ) |
SizeFamilyID (FK)(PK) | A unique retailer assigned idendtifier for the grouping of similar colors used to classify the sizes of merchandise for analysis. | ID_SZ_FMY | Identity | integer | Size(CO_SZ) |